干饭FFing

redhat6静默安装oracle11.2.0.4.0 及问题

redhat6.7已验证：一键安装

环境：jdk1.8

两个安装包：p13390677_112040_Linux-x86-64_1of7.zip p13390677_112040_Linux-x86-64_2of7.zip

init_ok.sh

未验证 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
#!/bin/bash

#sh
SHPATH=`readlink -f $0`
SHDIR=`dirname $SHPATH`

#关闭selinux
sed -i 's@SELINUX=enforcing@SELINUX=disabled@' /etc/selinux/config

#关闭防火墙
service iptables stop
chkconfig iptables off

#修改主机名
sed -i '/HOSTNAME/c HOSTNAME=oracle' /etc/sysconfig/network

#hosts
echo "`hostname -I` oracle" >>/etc/hosts




#安装zip工具
yum -y install unzip
if [ ! $? -eq 0 ];then echo "yum install unzip  error!" ;fi


#解压oracle
ZIP_UNDIR=/opt/oracle_install
ZIP=`find $SHDIR -type f -name "p13390677_112040_Linux-x86-64_*of7.zip"`
for i in `echo $ZIP`
do
unzip $i -d $ZIP_UNDIR
done
chmod -R 777 $ZIP_UNDIR

#java
tar -xvf $SHDIR/jdk* -C $SHDIR
JAVA=`find $SHDIR -maxdepth 1 -name "jdk*"`
mv $JAVA java8
mv java8 /usr/local

echo '
export JAVA_HOME=/usr/local/java8
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH} 
'  >> /etc/profile
source /etc/profile


#安装依赖
yum -y install \
binutils \
compat-libcap1  \
compat-libstdc++-33 \
compat-libstdc++-33*.i686 \
elfutils-libelf-devel \
gcc \
gcc-c++ \
glibc*.i686 \
glibc \
glibc-devel \
glibc-devel*.i686 \
ksh \
libgcc*.i686 \
libgcc \
libstdc++ \
libstdc++*.i686 \
libstdc++-devel \
libstdc++-devel*.i686 \
libaio \
libaio*.i686 \
libaio-devel \
libaio-devel*.i686 \
make \
sysstat \
unixODBC \
unixODBC*.i686 \
unixODBC-devel \
unixODBC-devel*.i686 \
libXp \
libXext \
libXext-devel

yum install binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* elfutils-libelf-devel-* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh-2* libaio-0.* libaio-devel-0.* libgcc-4.* libstdc++-4.* libstdc++-devel-4.* make-3.* sysstat.* unixODBC-2.* unixODBC-devel-2.* ksh*
yum  install  libaio-0.*  glibc-2.*  compat-libstdc++-33*  libaio-devel-0.*  libgcc*  unixODBC-2.* unixODBC-devel-2.* ksh*




#oracle用户限制/etc/security/limits.conf
echo '
oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536
' >>/etc/security/limits.conf

#oracle鉴权模块 /etc/pam.d/login
echo '
session required /lib/security/pam_limits.so
 session required pam_limits.so
' >>/etc/pam.d/login


#内核/etc/sysctl.conf
echo '
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
' >> /etc/sysctl.conf
sysctl -p


#全局环境/etc/profile
echo '
if [ $USER = "oracle" ]; then

    if [ $SHELL = "/bin/ksh" ]; then

        ulimit -p 16384

        ulimit -n 65536

    else

        ulimit -u 16384 -n 65536

    fi

fi 
' >>/etc/profile
source /etc/profile

#创建用户
groupadd dba
groupadd oinstall
useradd -g oinstall -G dba -m oracle
echo "oracle:oracle"|chpasswd



#创建安装目录


#创建安装目录
mkdir -p /oracle/product/11.2.0/dbhome_1
#数据文件存放目录
mkdir -p /oracle/oradata
#数据恢复目录
mkdir -p /oracle/recovery_area
#数据库创建及使用过程中的日志目录
mkdir -p /oracle/oraInventory

#修改安装目录权限
chown -R oracle:oinstall /oracle
chmod 775 /oracle

#oracle用户环境变量
echo '  
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64
export ORACLE_SID=oracle
export LANG=en_US 
# Oracle client
#export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK 
#如果设置NLS_LANG，容易产生导入sql或dmp出错，因为其他环境下的不是utf8
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
' >>/home/oracle/.bash_profile



#响应文件 db_install_orcl.rsp

echo '
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=oracle
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/oracle/product/11.2.0.4/dbhome_1
ORACLE_BASE=/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=oracle
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
'> $ZIP_UNDIR/database/db_install_orcl.rsp


chmod -R 777 $ZIP_UNDIR



# #静默安装
su -  oracle  <<EOF
cd $ZIP_UNDIR/database
#!!!db_install_orcl.rsp!!!必须使用绝对路径
./runInstaller -silent -responseFile $ZIP_UNDIR/database/db_install_orcl.rsp -ignorePrereq
EOF

常见错误 

1
2
3
4
5
[WARNING] [INS-32055] The Central Inventory is located in the Oracle base.
   CAUSE: The Central Inventory is located in the Oracle base.
   ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory.
解决方法：
提示日志应该在oracle安装目录之外，可忽略

1
2
3
4
5
6
7
CAUSE: Some of the optional prerequisites are not met. See logs for details
   ACTION: Identify the list of failed prerequisite checks from the log
 opriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
 /u01/oracle/oralnventory/logs/installActions2023-09-26_09-48-45PM.log

原因：不满足先决条件，请查看日志

日志错误 

1
2
3
4
5
6
7
INFO: Package: pdksh-5.2.14: This is a prerequisite condition to test whether the package "pdksh-5.2.14" is available on the system.
INFO: Severity:IGNORABLEINFO: OverallStatus:VERIFICATION_FAILEDINFO: -----------------------------------------------
INFO: Verification Result for Node:adg
INFO: Expected Value:pdksh-5.2.14INFO: Actual Value:missing
INFO: Error Message:PRVF-7532 : Package "pdksh" is missing on node "adg"
INFO: Cause: A required package is either not installed or, if the package is a kernel module, is not loaded on the specified node.
INFO: Action: Ensure that the required package is installed and available.

解决 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
1.忽略该警告，继续下一步安装(推荐)
2.网上下载单独该包的pdksh.rpm包安装,需先卸载默认的ksh(不推荐)

问题原因：是redhat的bug
由于无法确认操作系统版本信息，这使OUI认为该服务器不是RHEL服务器。
由于OUI无法识别服务器的类型，因此OUI会执行默认（OEL4）前提条件检查。
这个是Oracle unpublished（未发布的） bug 13981169。
在redhat5中执行
[root@oracle ~]# /bin/rpm -q --qf %{version} redhat-release
5Server

在redhat6中执行
[oracle@adg database]$ /bin/rpm -q --qf %{version} redhat-release
package redhat-release is not installed
实际执行命令为
[oracle@adg database]$ /bin/rpm -q --qf %{version} redhat-release-server-6Server
6Server


强迫症解决方法：
#修改OEL4改为OEL6
sed -i '/CV_ASSUME_DISTID=OEL4/c CV_ASSUME_DISTID=OEL6' 解压包目录/database/stage/cvu/cv/admin/cvu_config

一键安装，我的gitee包或阿里网盘下载资源 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
#sh

#安装用户
ORACLE_USER=oracle
ORACLE_PWD=oracle
#组
ORA_INS_GP=oinstall
ORA_DBA_GP=dba
#解压目录
ORACLE_UNDIR=/home/oracle


#环境
HOST_NAME=oracle
ORACLE_SID=orcl
ORACLE_BASE=/data/oracle
ORACLE_HOME=/data/oracle/db_home
ORACLE_LOGS=/data/oracle/oralnventory
#####################################################
#sh
SHPATH=`readlink -f $0`
SHDIR=`dirname $SHPATH`

yum -y install unzip >/dev/null

#java
java -version >/dev/null 2>&1
if [ ! $? -eq 0 ];then
echo 配置jdk
cd $SHDIR
tar -xf  jdk-8u381-linux-x64.tar.gz 
mv jdk1.8.0_381 java8
rm -rf /usr/local/java8
mv java8 /usr/local
echo '
export JAVA_HOME=/usr/local/java8
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH} 
'  >> /etc/profile
source /etc/profile
java -version
fi







#关闭selinux
echo "关闭selinux"
setenforce 0
sed -i 's@SELINUX=enforcing@SELINUX=disabled@' /etc/selinux/config

#关闭防火墙
echo "关闭防火墙"
service iptables stop
chkconfig iptables off

#修改主机名
echo "修改主机名：$HOST_NAME"
sed -i "/HOSTNAME/c HOSTNAME=$HOST_NAME" /etc/sysconfig/network
#hosts
echo "`hostname -I|xargs -n1|grep -v [a-Z]` $HOST_NAME" >>/etc/hosts





#创建组、用户
echo "创建用户：$ORACLE_USER"
groupadd $ORA_INS_GP 
groupadd $ORA_DBA_GP
useradd -g $ORA_INS_GP  -G $ORA_DBA_GP $ORACLE_USER
echo "$ORACLE_USER:$ORACLE_PWD" |chpasswd


#全局环境
echo '
if [ \$USER = "$ORACLE_USER" ];then
        if [ \$SHELL = "/bin/ksh" ];then
                ulimit -p 16384
                ulimit -n 65536
        else
                ulimit -u 16384 -n 65536
        fi
        umask 022
fi
' >> /etc/profile


#创建目录
echo "创建目录"
mkdir -p $ORACLE_BASE $ORACLE_HOME $ORACLE_LOGS
chown -R $ORACLE_USER:$ORA_INS_GP $ORACLE_BASE
chmod -R 755 $ORACLE_BASE


#用户环境变量
echo "用户环境变量"
echo "
export ORACLE_SID=$ORACLE_SID
export ORACLE_BASE=$ORACLE_BASE
export ORACLE_HOME=$ORACLE_HOME
">>/home/oracle/.bash_profile
echo '
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
' >>/home/oracle/.bash_profile




#内核
echo "修改内核"
MEMTOTAL=$(free -b | sed -n '2p' | awk '{print $2}') 
SHMMAX=$(expr $MEMTOTAL / 2)
SHMMNI=4096
PAGESIZE=$(getconf PAGE_SIZE)
cat >> /etc/sysctl.conf << EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = $SHMMAX
kernel.shmall = $(expr \( $SHMMAX / $PAGESIZE \) \* \( $SHMMNI / 16 \))
kernel.shmmni = $SHMMNI
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
EOF
sysctl -p >/dev/null

#用户控制
echo "
$ORACLE_USER  soft  nproc   2047
$ORACLE_USER  hard  nproc   16384
$ORACLE_USER  soft  nofile  1024
$ORACLE_USER  hard  nofile  65536
$ORACLE_USER  soft  stack   10240
$ORACLE_USER  hard  stack   32768
" >> /etc/security/limits.conf

#鉴权
cat <<EOF>>/etc/pam.d/login
session required /lib64/security/pam_limits.so
EOF











#
echo "解压oracle"
unzip p13390677_112040_Linux-x86-64_1of7.zip -d $ORACLE_UNDIR  >/dev/null
unzip p13390677_112040_Linux-x86-64_2of7.zip -d $ORACLE_UNDIR  >/dev/null

#
echo "配置响应文件：db_install"
echo "
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=$HOST_NAME

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=$ORACLE_LOGS

SELECTED_LANGUAGES=en,zh_CN,zh_TW

ORACLE_HOME=$ORACLE_HOME

ORACLE_BASE=$ORACLE_BASE

oracle.install.db.InstallEdition=EE

oracle.install.db.EEOptionsSelection=false

oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=oinstall

oracle.install.db.CLUSTER_NODES=

oracle.install.db.isRACOneInstall=

oracle.install.db.racOneServiceName=

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

oracle.install.db.config.starterdb.globalDBName=$ORACLE_SID

oracle.install.db.config.starterdb.SID=$ORACLE_SID

oracle.install.db.config.starterdb.characterSet=AL32UTF8

oracle.install.db.config.starterdb.memoryOption=true

oracle.install.db.config.starterdb.memoryLimit=1500

oracle.install.db.config.starterdb.installExampleSchemas=false

oracle.install.db.config.starterdb.enableSecuritySettings=true

oracle.install.db.config.starterdb.password.ALL=oracle

oracle.install.db.config.starterdb.password.SYS=

oracle.install.db.config.starterdb.password.SYSTEM=

oracle.install.db.config.starterdb.password.SYSMAN=

oracle.install.db.config.starterdb.password.DBSNMP=

oracle.install.db.config.starterdb.control=DB_CONTROL

oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

oracle.install.db.config.starterdb.automatedBackup.enable=false

oracle.install.db.config.starterdb.automatedBackup.osuid=

oracle.install.db.config.starterdb.automatedBackup.ospwd=

oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=$ORACLE_BASE/oradata

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=$ORACLE_BASE/fast_recovery_area
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=

MYORACLESUPPORT_USERNAME=

MYORACLESUPPORT_PASSWORD=

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true
PROXY_HOST=

PROXY_PORT=

PROXY_USER=

PROXY_PWD=

PROXY_REALM=

COLLECTOR_SUPPORTHUB_URL=

oracle.installer.autoupdates.option=SKIP_UPDATES

oracle.installer.autoupdates.downloadUpdatesLoc=

AUTOUPDATES_MYORACLESUPPORT_USERNAME=

AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
" >$ORACLE_UNDIR/database/response/db_install.rsp

echo "配置响应文件：dbca"
echo "
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "$ORACLE_SID"
SID = "$ORACLE_SID"
SYSPASSWORD = "$ORACLE_PWD"
SYSTEMPASSWORD = "$ORACLE_PWD"
SYSMANPASSWORD = "$ORACLE_PWD"
DBSNMPPASSWORD = "$ORACLE_PWD"
DATAFILEDESTINATION = /data/oracle/oradata
RECOVERYAREADESTINATION= /data/oracle/flash_recovery_area
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL32UTF8"
TOTALMEMORY = "3200"
" > $ORACLE_UNDIR/database/response/dbca.rsp


echo '
TEMPLATENAME = "General_Purpose.dbc"
[createTemplateFromDB]
SOURCEDB = "myhost:1521:orcl"
SYSDBAUSERNAME = "system"
TEMPLATENAME = "My Copy TEMPLATE"
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
[generateScripts]
TEMPLATENAME = "New Database"
GDBNAME = "orcl11.us.oracle.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
NODELIST=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
INSTANCENAME = "orcl11g"
SYSDBAUSERNAME = "sys"
' >> $ORACLE_UNDIR/database/response/dbca.rsp

chown -R $ORACLE_USER:$ORA_INS_GP $ORACLE_UNDIR

#安装依赖
echo "安装依赖"
yum -y install binutils binutils-devel compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 ksh elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel glibc-headers gcc gcc-c++ libaio libaio.i686 libaio-devel libaio-devel.i686 libgcc libstdc++ libstdc++.i686 libstdc++-devel libstdc++-devel.i686 make sysstat unixODBC unixODBC-devel libXp libXp-devel libXpm-devel telnet unzip >/dev/null




#reboot
#检测初始化状态

echo "
while true 
do
        #检测状态
        cat  /tmp/db_install_init.log|grep $ORACLE_HOME/root.sh >/dev/null
        if [  $? -eq 0 ];then 
        sleep 2
        echo "root执行"
        find $ORACLE_LOGS -type f -name orainstRoot.sh |xargs -i bash {}
        find $ORACLE_HOME -type f -name root.sh |xargs -i {}
        break
        fi
sleep 1
done

sleep 60

while true
do
sleep 1
find $ORACLE_HOME -type f -name netca|grep netca >/dev/null
if [ ! $? -eq 0 ];then  continue;fi
echo ----------------
echo $ORACLE_HOME
ls -l $ORACLE_HOME
echo ----------------


su - $ORACLE_USER << EOF
echo "创建监听"
$ORACLE_HOME/bin/netca -silent -responsefile  $ORACLE_UNDIR/database/response/netca.rsp
echo "创建数据库"
$ORACLE_HOME/bin/dbca -createDatabase -responseFile $ORACLE_UNDIR/database/response/dbca.rsp
EOF
break
done






">/tmp/db_install_check.sh

chmod 777 /tmp/db_install_check.sh
nohup /tmp/db_install_check.sh >/tmp/db_install_check.log &

#初始化
echo "初始化"
su - $ORACLE_USER << EOF |tee /tmp/db_install_init.log 
$ORACLE_UNDIR/database/runInstaller -silent -force -noconfig -responseFile $ORACLE_UNDIR/database/response/db_install.rsp 


EOF


tail -f /tmp/db_install_check.log
图片预览
100%